Data Mining And Data Warehousing
OLAP operations
OLAP Operations
OLAP = Online Analytical Processing. These are operations that allow users to interactively explore multidimensional data cubes.
Key OLAP Operations:
| Operation | Description | Example |
|---|---|---|
| Roll-up | Aggregates data by climbing up a dimension hierarchy | From days to months, or cities to countries |
| Drill-down | Opposite of roll-up: goes to finer granularity | From year to quarter, or country to city |
| Slice | Selects a single value for one dimension, reducing dimensionality | Sales for January |
| Dice | Selects a subcube by specifying ranges on multiple dimensions | Sales for Q1 and for Asia |
| Pivot (Rotate) | Reorients the cube view for different perspectives | Swap rows and columns in a report |